package com.dz.tool;

import com.dz.tool.Service.HibernateServer;
import com.dz.tool.Service.MysqlServer;
import com.dz.tool.Service.OracleServer;
import com.dz.tool.Service.SQLServerServer;
import org.apache.catalina.connector.Response;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;
import org.springframework.context.ConfigurableApplicationContext;
import org.springframework.context.annotation.Configuration;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Configuration
@MapperScan("com.dz.tool.Dao")
@SpringBootApplication(exclude = {DataSourceAutoConfiguration.class})
public class PublicsecurityApplication {


    public static void main(String[] args) throws Exception {
        ConfigurableApplicationContext run = SpringApplication.run(PublicsecurityApplication.class, args);

        // 备份--》中转原始--》新库预备--》新库


        // 备份--》中转原始
        // 承保
//        B_Z_CB(run);
        // 理赔
//        B_Z_LP(run);
        // 单证
//        B_Z_DZ(run);


        // 中转原始--》新库预备
        // 承保
//        Z_BASE(run);
//        tableYears_CB(run);
        // 理赔
//        tableYears_LP(run);
//        tableYS_LP(run);
        // 单证
//        tableYears_DZ(run);
//        tableYears_DZ2(run);

        // 创建年表
//        tableYear(run);




        // 备份到单证
//        B_M(run);


        System.out.println("======OK======");
    }

    // 备份--》中转原始--》新库预备--》新库

    // 备份--》中转原始
    public static void B_Z_CB(ConfigurableApplicationContext run){
        OracleServer oracleServer = run.getBean(OracleServer.class);
        List<Map<String,String>> OracleTableList = new ArrayList<>();
        Map<String,String> table = new HashMap<>();

//        table = new HashMap<>();
//        table.put("table","WEB_PLY_CI");
//        table.put("id","C_PK_ID");
//        table.put("way","increment");  // increment || all
//        table.put("inc_field","T_UPD_TM");
//        OracleTableList.add(table);

//        table = new HashMap<>();
//        table.put("table","WEB_PLY_TGT_OBJ");
//        table.put("id","C_PK_ID");
//        table.put("way","increment");  // increment || all
//        table.put("inc_field","T_UPD_TM");
//        OracleTableList.add(table);



        oracleServer.OracleToOracleIncrementTableList(OracleTableList);
    }

    // 备份--》中转原始
    public static void B_Z_LP(ConfigurableApplicationContext run){
        OracleServer oracleServer = run.getBean(OracleServer.class);
        List<Map<String,String>> OracleTableList = new ArrayList<>();
        Map<String,String> table = new HashMap<>();


        oracleServer.OracleToOracleIncrementTableList(OracleTableList);
    }

    // 备份--》中转原始
    public static void B_Z_DZ(ConfigurableApplicationContext run){
        OracleServer oracleServer = run.getBean(OracleServer.class);
        List<Map<String,String>> OracleTableList = new ArrayList<>();
        Map<String,String> table = new HashMap<>();


        oracleServer.OracleToOracleIncrementTableList(OracleTableList);
    }


    // 中转 -》 中转新结构
    public static void Z_BASE(ConfigurableApplicationContext run){
        OracleServer oracleServer = run.getBean(OracleServer.class);
//        oracleServer.OracleToOracleIncrementCAppNo();

        List<Map<String,String>> OracleTableList = new ArrayList<>();
        Map<String,String> table = new HashMap<>();

        table = new HashMap<>();
        table.put("table_load","WEB_PLY_BASE");
        table.put("table_new","WEB_PLY_BASE,WEB_PLY_SPECIAL_AGREEMENT,WEB_PLY_SPECIAL_INF,WEB_MIGRATE_APPNO");
        table.put("WEB_PLY_BASE_id","c_app_no");
        table.put("WEB_PLY_SPECIAL_AGREEMENT_id","c_pk_id");
        table.put("WEB_PLY_SPECIAL_INF_id","c_app_no");
        table.put("WEB_MIGRATE_APPNO_id","C_APP_NO");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        OracleTableList.add(table);

        oracleServer.BaseTONewTable(OracleTableList);
    }


    public static void tableYears_DZ(ConfigurableApplicationContext run){
        OracleServer oracleServer = run.getBean(OracleServer.class);

        List<Map<String,String>> OracleTableList = new ArrayList<>();
        Map<String,String> table = new HashMap<>();

        table = new HashMap<>();
        table.put("table_load","WEB_VCH_PGHLIST");
        table.put("table_new","WEB_VCH_PGHLIST");
        table.put("table_load_id","C_PK_ID");
        table.put("WEB_VCH_PGHLIST_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        OracleTableList.add(table);

        oracleServer.tableTONewTableYearsCG3(OracleTableList);
    }
    public static void tableYears_DZ2(ConfigurableApplicationContext run){
        OracleServer oracleServer = run.getBean(OracleServer.class);

        List<Map<String,String>> OracleTableList = new ArrayList<>();
        Map<String,String> table = new HashMap<>();


//        table = new HashMap<>();
//        table.put("table_load","WEB_PRN_FMP");
//        table.put("table_load_id","C_PRN_FMP");
//        table.put("table_new","WEB_PRN_FMP");
//        table.put("WEB_PRN_FMP_id","c_prn_fmp");
//        table.put("way","increment");  // increment || all
//        table.put("inc_field","T_UPD_TM");
//        table.put("BTS","M");
//        table.put("year_cs","false");
//        OracleTableList.add(table);


        oracleServer.tableTONewTableYearsCG(OracleTableList);
    }

    public static void tableYears_CB(ConfigurableApplicationContext run){
        OracleServer oracleServer = run.getBean(OracleServer.class);

        List<Map<String,String>> OracleTableList = new ArrayList<>();
        Map<String,String> table = new HashMap<>();

//        table = new HashMap<>();
//        table.put("table_load","WEB_PLY_BASE");
//        table.put("table_load_id","C_APP_NO");
//        table.put("table_new","WEB_PLY_SPECIAL_INF");
//        table.put("WEB_PLY_SPECIAL_INF_id","C_APP_NO");
//        table.put("way","increment");  // increment || all
//        table.put("inc_field","T_UPD_TM");
//        table.put("filed","C_PK_ID,C_APP_NO,C_ROW_ID,C_PLY_NO,N_EDR_PRJ_NO,C_EDR_NO,C_FEETYP_CDE,N_FEE_PROP,N_FEE,N_GOT_PRM,C_LATEST_MRK,T_CRT_TM,T_UPD_TM,C_TRANS_MRK,T_TRANS_TM,C_FEE_FLAG,N_UPD_FEE_PROP,N_UPD_FEE,C_CRT_CDE,C_UPD_CDE,C_UPD_CRT_C");
//        table.put("BTS","D");
//        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_PLY_CI");
        table.put("table_load_id","C_PK_ID");
        table.put("table_new","WEB_PLY_CI");
        table.put("WEB_PLY_CI_id","c_pk_id");
        table.put("way","increment");  // increment || all
        table.put("inc_field","T_UPD_TM");
        table.put("filed","C_PK_ID,C_APP_NO,C_ROW_ID,C_PLY_NO,N_EDR_PRJ_NO,C_EDR_NO,N_SEQ_NO,C_CI_AGRMNT_NO,C_MAJOR_AGRMNT_MRK,C_COINSURER_CDE,C_CHIEF_MRK,C_ISSUE_MRK,N_CI_SHARE,N_CI_AMT,N_CI_RATE,N_CI_PRM,N_COMM,N_PLY_FEE,N_CI_AMT_VAR,N_CI_PRM_VAR,N_COMM_VAR,N_PLY_FEE_VAR,C_SELF_MRK,C_LATEST_MRK,T_CRT_TM,T_UPD_TM,C_TRANS_MRK,T_TRANS_TM,C_CI_SUB_COMP,N_PLY_FEE_RATE,C_CRT_CDE,C_UPD_CDE,C_DPT_CDE,C_SLS_ID,C_BRKR_CDE,C_BRK_SLS_CDE,C_JI_MRK,C_AGT_AGR_NO,N_NOTAX_PRM,N_ADDED_TAX,N_NOTAX_PRM_VAR,N_ADDED_TAX_VAR,N_NOTAX_PLY_FEE,N_NOTAX_PLY_FEE_VAR,N_ADDED_TAX_FEE,N_ADDED_TAX_FEE_VAR,N_CI_NET_PRM,N_CI_NET_PRM_VAR,C_ACCT_NO,C_ACCT_NME,C_BANK_REL_TYP,C_BANK_PRO,C_BANK_AREA,C_BANK_COUNTY,C_BANK_CDE,C_BANK_CNAPS,C_BANK_ADDR,C_POLICY_NO");
        table.put("filed_n","C_PK_ID,C_APP_NO,C_ROW_ID,C_PLY_NO,N_EDR_PRJ_NO,C_EDR_NO,N_SEQ_NO,C_CI_AGRMNT_NO,C_MAJOR_AGRMNT_MRK,C_COINSURER_CDE,C_CHIEF_MRK,C_ISSUE_MRK,N_CI_SHARE,N_CI_AMT,N_CI_RATE,N_CI_PRM,N_COMM,N_PLY_FEE,N_CI_AMT_VAR,N_CI_PRM_VAR,N_COMM_VAR,N_PLY_FEE_VAR,C_SELF_MRK,C_LATEST_MRK,T_CRT_TM,T_UPD_TM,C_TRANS_MRK,T_TRANS_TM,C_CI_SUB_COMP,N_PLY_FEE_RATE,C_CRT_CDE,C_UPD_CDE,C_DPT_CDE,C_SLS_ID,C_BRKR_CDE,C_BRK_SLS_CDE,C_JI_MRK,C_AGT_AGR_NO,N_NOTAX_PRM,N_ADDED_TAX,N_NOTAX_PRM_VAR,N_ADDED_TAX_VAR,N_NOTAX_PLY_FEE,N_NOTAX_PLY_FEE_VAR,N_ADDED_TAX_FEE,N_ADDED_TAX_FEE_VAR,N_CI_NET_PRM,N_CI_NET_PRM_VAR,C_ACCT_NO,C_ACCT_NME,C_BANK_REL_TYP,C_BANK_PRO,C_BANK_AREA,C_BANK_COUNTY,C_BANK_CDE,C_BANK_CNAPS,C_BANK_ADDR,C_POLICY_NO");
        table.put("BTS","D");
        OracleTableList.add(table);


//        table = new HashMap<>();
//        table.put("table_load","WEB_PLY_BASE");
//        table.put("table_load_id","C_APP_NO");
//        table.put("table_new","WEB_PLY_SPECIAL_AGREEMENT");
//        table.put("WEB_PLY_SPECIAL_AGREEMENT_id","C_APP_NO");
//        table.put("way","increment");  // increment || all
//        table.put("inc_field","T_UPD_TM");
//        table.put("filed","C_PK_ID,C_APP_NO,C_ROW_ID,C_PLY_NO,N_EDR_PRJ_NO,C_EDR_NO,N_SEQ_NO,C_CI_AGRMNT_NO,C_MAJOR_AGRMNT_MRK,C_COINSURER_CDE,C_CHIEF_MRK,C_ISSUE_MRK,N_CI_SHARE,N_CI_AMT,N_CI_RATE,N_CI_PRM,N_COMM,N_PLY_FEE,N_CI_AMT_VAR,N_CI_PRM_VAR,N_COMM_VAR,N_PLY_FEE_VAR,C_SELF_MRK,C_LATEST_MRK,T_CRT_TM,T_UPD_TM,C_TRANS_MRK,T_TRANS_TM,C_CI_SUB_COMP,N_PLY_FEE_RATE,C_CRT_CDE,C_UPD_CDE,C_DPT_CDE,C_SLS_ID,C_BRKR_CDE,C_BRK_SLS_CDE,C_JI_MRK,C_AGT_AGR_NO,N_NOTAX_PRM,N_ADDED_TAX,N_NOTAX_PRM_VAR,N_ADDED_TAX_VAR,N_NOTAX_PLY_FEE,N_NOTAX_PLY_FEE_VAR,N_ADDED_TAX_FEE,N_ADDED_TAX_FEE_VAR,N_CI_NET_PRM,N_CI_NET_PRM_VAR,C_ACCT_NO,C_ACCT_NME,C_BANK_REL_TYP,C_BANK_PRO,C_BANK_AREA,C_BANK_COUNTY,C_BANK_CDE,C_BANK_CNAPS,C_BANK_ADDR,C_POLICY_NO");
//        table.put("filed_n","C_PK_ID,C_APP_NO,C_ROW_ID,C_PLY_NO,N_EDR_PRJ_NO,C_EDR_NO,N_SEQ_NO,C_CI_AGRMNT_NO,C_MAJOR_AGRMNT_MRK,C_COINSURER_CDE,C_CHIEF_MRK,C_ISSUE_MRK,N_CI_SHARE,N_CI_AMT,N_CI_RATE,N_CI_PRM,N_COMM,N_PLY_FEE,N_CI_AMT_VAR,N_CI_PRM_VAR,N_COMM_VAR,N_PLY_FEE_VAR,C_SELF_MRK,C_LATEST_MRK,T_CRT_TM,T_UPD_TM,C_TRANS_MRK,T_TRANS_TM,C_CI_SUB_COMP,N_PLY_FEE_RATE,C_CRT_CDE,C_UPD_CDE,C_DPT_CDE,C_SLS_ID,C_BRKR_CDE,C_BRK_SLS_CDE,C_JI_MRK,C_AGT_AGR_NO,N_NOTAX_PRM,N_ADDED_TAX,N_NOTAX_PRM_VAR,N_ADDED_TAX_VAR,N_NOTAX_PLY_FEE,N_NOTAX_PLY_FEE_VAR,N_ADDED_TAX_FEE,N_ADDED_TAX_FEE_VAR,N_CI_NET_PRM,N_CI_NET_PRM_VAR,C_ACCT_NO,C_ACCT_NME,C_BANK_REL_TYP,C_BANK_PRO,C_BANK_AREA,C_BANK_COUNTY,C_BANK_CDE,C_BANK_CNAPS,C_BANK_ADDR,C_POLICY_NO");
//        table.put("BTS","D");
//        OracleTableList.add(table);


        oracleServer.tableTONewTableYearsCG(OracleTableList);
    }

    public static void tableYears_LP(ConfigurableApplicationContext run){
        OracleServer oracleServer = run.getBean(OracleServer.class);

        List<Map<String,String>> OracleTableList = new ArrayList<>();
        Map<String,String> table = new HashMap<>();


        oracleServer.tableTONewTableCG(OracleTableList);
    }

    public static void tableYS_LP(ConfigurableApplicationContext run){
        OracleServer oracleServer = run.getBean(OracleServer.class);

        List<Map<String,String>> OracleTableList = new ArrayList<>();
        Map<String,String> table = new HashMap<>();

//        table = new HashMap<>();
//        table.put("table_load","WEB_VCH_PGH");
//        table.put("table_new","WEB_VCH_PGH");
//        table.put("WEB_VCH_PGH_id","c_pgh_no");
//        table.put("way","increment");  // increment || all
//        table.put("inc_field","T_UPD_TM");
//        table.put("BTS","B");
//        OracleTableList.add(table);


//        table = new HashMap<>();
//        table.put("table_load","WEB_CLM_ACCDNT");
//        table.put("table_new","WEB_CLM_ACCDNT");
//        table.put("WEB_CLM_ACCDNT_id","C_INS_ACC_PK_ID");
//        table.put("way","increment");  // increment || all
//        table.put("inc_field","T_UPD_TM");
//        table.put("filed","C_INS_ACC_PK_ID, C_CLM_NO, C_INSURED_CDE, C_INSURED_NME, C_SEX, N_AGE, C_CERT_TYP, C_CERT_NO, C_OCCUP_CDE, T_ACCDNT_TM, C_ACCDNT_TYP, C_ACCDNT_RSN, C_ACCDNT_PLACE, C_ACCDNT_PROC, N_RPT_AMT, C_RPT_CUR, C_REMARK, T_RPT_ACCDNT_TM, C_RPT_ACCDNT_TYP, C_RPT_ACCDNT_RSN, C_RPT_ACCDNT_PLACE, C_RPT_ACCDNT_PROC, C_CRT_CDE, T_CRT_TM, C_UPD_CDE, T_UPD_TM, C_TRANS_MRK, T_TRANS_TM, N_DISASTER_RPT_AMT, N_NOGAIN_RPT_AMT, C_RPT_ACCDNT_WITH_RSN, N_YL4, N_YL5, C_IS_INJURY, C_HOSPITAL, C_INSTANT_DELAY, C_HUGE_CDE, C_HUGE_MRK, C_YL1, T_DATE_BIRTH, C_PROVINCE, C_CITY, C_COUNTY, C_INJURY_REASON_CODE, NULL AS C_SCALE, NULL AS C_IS_PAY, NULL AS C_HUGE_ONE_CDE, NULL AS C_HUGE_TWO_CDE, NULL AS C_RPT_ACCDNT_PLACE_DETAIL, NULL AS C_EMAIL, NULL AS C_RPT_ACCDNT_RSN_NAME, NULL AS C_RPT_ACCDNT_RSNNAME1, NULL AS C_RPT_ACCDNT_RSNNAME2, NULL AS C_OCCUP_DTL, NULL AS C_OCCUP_CNM, NULL AS C_OCCUP_TYPE, C_COST_PROC, NULL AS C_EDR_NO, NULL AS C_SUB_GRP_NO, N_PSN_NUM, NULL AS C_ACCDNT_STATE_TYP, NULL AS C_OFF_SITE_RISK, NULL AS C_DIE_NUMBER");
//        table.put("filed_n","C_INS_ACC_PK_ID, C_CLM_NO, C_INSURED_CDE, C_INSURED_NME, C_SEX, N_AGE, C_CERT_TYP, C_CERT_NO, C_OCCUP_CDE, T_ACCDNT_TM, C_ACCDNT_TYP, C_ACCDNT_RSN, C_ACCDNT_PLACE, C_ACCDNT_PROC, N_RPT_AMT, C_RPT_CUR, C_REMARK, T_RPT_ACCDNT_TM, C_RPT_ACCDNT_TYP, C_RPT_ACCDNT_RSN, C_RPT_ACCDNT_PLACE, C_RPT_ACCDNT_PROC, C_CRT_CDE, T_CRT_TM, C_UPD_CDE, T_UPD_TM, C_TRANS_MRK, T_TRANS_TM, N_DISASTER_RPT_AMT, N_NOGAIN_RPT_AMT, C_RPT_ACCDNT_WITH_RSN, N_YL4, N_YL5, C_IS_INJURY, C_HOSPITAL, C_INSTANT_DELAY, C_HUGE_CDE, C_HUGE_MRK, C_YL1, T_DATE_BIRTH, C_PROVINCE, C_CITY, C_COUNTY, C_INJURY_REASON_CODE, C_SCALE, C_IS_PAY, C_HUGE_ONE_CDE, C_HUGE_TWO_CDE, C_RPT_ACCDNT_PLACE_DETAIL, C_EMAIL, C_RPT_ACCDNT_RSN_NAME, C_RPT_ACCDNT_RSNNAME1, C_RPT_ACCDNT_RSNNAME2, C_OCCUP_DTL, C_OCCUP_CNM, C_OCCUP_TYPE, C_COST_PROC, C_EDR_NO, C_SUB_GRP_NO, N_PSN_NUM, C_ACCDNT_STATE_TYP, C_OFF_SITE_RISK, C_DIE_NUMBER");
//        table.put("BTS","M");
//        table.put("lowerCase","false");
//        table.put("year_cs","false");
//        OracleTableList.add(table);


        // 非空问题
//        table = new HashMap<>();
//        table.put("table_load","WEB_CLM_RPT_REMARKS");
//        table.put("table_new","WEB_CLM_CASE_STATE");
//        table.put("WEB_CLM_CASE_STATE_id","C_PK_ID");
//        table.put("way","increment");  // increment || all
//        table.put("inc_field","T_UPD_TM");
//        table.put("filed","C_PK_ID AS C_PK_ID,\n" +
//                "  C_CLM_NO AS C_CLM_NO,\n" +
//                "  NULL AS C_INSURED_CDE,\n" +
//                "  NULL AS C_INSURED_NME,\n" +
//                "  (SELECT t.C_DPT_CDE FROM WEB_ORG_EMP t WHERE t.C_EMP_CDE = WEB_CLM_RPT_REMARKS.C_CRT_CDE) AS C_CASE_DPT,\n" +
//                "  C_CRT_CDE AS C_CASE_CDE,\n" +
//                "  T_RMK_TM AS T_CASE_TM,\n" +
//                "  C_CRT_CDE AS C_CRT_CDE,\n" +
//                "  T_CRT_TM AS T_CRT_TM,\n" +
//                "  C_UPD_CDE AS C_UPD_CDE,\n" +
//                "  T_UPD_TM AS T_UPD_TM,\n" +
//                "  NULL AS CURT_TASK_NAME_,\n" +
//                "  C_REMARKS AS C_CASE_OPIN,\n" +
//                "  NULL AS C_TASKNAME_ID,\n" +
//                "  NULL AS IS_DELETE");
//        table.put("filed_n","C_PK_ID,C_CLM_NO,C_INSURED_CDE,C_INSURED_NME,C_CASE_DPT,C_CASE_CDE,T_CASE_TM,C_CRT_CDE,T_CRT_TM,C_UPD_CDE,T_UPD_TM,CURT_TASK_NAME_,C_CASE_OPIN,C_TASKNAME_ID,IS_DELETE");
//        table.put("BTS","M");
//        table.put("lowerCase","false");
//        table.put("year_cs","false");
//        OracleTableList.add(table);


//        table = new HashMap<>();
//        table.put("table_load","WEB_CLM_GUIDE_VIEW");
//        table.put("table_new","WEB_CLM_CASE_STATE");
//        table.put("WEB_CLM_CASE_STATE_id","C_PK_ID");
//        table.put("way","increment");  // increment || all
//        table.put("inc_field","T_UPD_TM");
//        table.put("filed","C_GUIDE_ID AS C_PK_ID,\n" +
//                "  C_CLM_NO AS C_CLM_NO,\n" +
//                "  NULL AS C_INSURED_CDE,\n" +
//                "  NULL AS C_INSURED_NME,\n" +
//                "  C_ORG_ID AS C_CASE_DPT,\n" +
//                "  C_CRT_CDE AS C_CASE_CDE,\n" +
//                "  T_CRT_TM AS T_CASE_TM,\n" +
//                "  C_CRT_CDE AS C_CRT_CDE,\n" +
//                "  T_CRT_TM AS T_CRT_TM,\n" +
//                "  C_UPD_CDE AS C_UPD_CDE,\n" +
//                "  T_UPD_TM AS T_UPD_TM,\n" +
//                "  NULL AS CURT_TASK_NAME_,\n" +
//                "  C_VIEW_CONTENT AS C_CASE_OPIN,\n" +
//                "  NULL AS C_TASKNAME_ID,\n" +
//                "  NULL AS IS_DELETE");
//        table.put("filed_n","C_PK_ID,C_CLM_NO,C_INSURED_CDE,C_INSURED_NME,C_CASE_DPT,C_CASE_CDE,T_CASE_TM,C_CRT_CDE,T_CRT_TM,C_UPD_CDE,T_UPD_TM,CURT_TASK_NAME_,C_CASE_OPIN,C_TASKNAME_ID,IS_DELETE");
//        table.put("BTS","M");
//        table.put("lowerCase","false");
//        table.put("year_cs","false");
//        OracleTableList.add(table);


        table = new HashMap<>();
        table.put("table_load","WEB_CLM_ACCDNT");
        table.put("table_load_id","C_INS_ACC_PK_ID");
        table.put("table_new","WEB_CLM_ACCDNT_INSURED");
        table.put("WEB_CLM_ACCDNT_INSURED_id","C_PK_ID");
        table.put("way","increment");  // increment || all
        table.put("inc_field","b.T_UPD_TM");
        table.put("filed","SYS_GUID() AS C_PK_ID,\n" +
                "  a.C_CLM_NO,\n" +
                "  a.C_INSURED_CDE,\n" +
                "  a.C_INSURED_NME,\n" +
                "  a.C_SEX,\n" +
                "  a.N_AGE,\n" +
                "  a.C_CERT_TYP,\n" +
                "  a.C_CERT_NO,\n" +
                "  a.C_OCCUP_CDE,\n" +
                "  a.C_CRT_CDE,\n" +
                "  a.T_CRT_TM,\n" +
                "  a.C_UPD_CDE,\n" +
                "  a.T_UPD_TM,\n" +
                "  NULL AS C_INJURED,\n" +
                "  a.C_HOSPITAL,\n" +
                "  a.C_ACCDNT_PK_ID,\n" +
                "  NULL AS C_OCCUP_DTL,\n" +
                "  NULL AS C_OCCUP_CNM,\n" +
                "  NULL AS C_OCCUP_TYPE,\n" +
                "  a.C_ACCDNT_CDE AS C_ACCDNT_CDE,\n" +
                "  a.C_ACCDNT_NME AS C_ACCDNT_NME,\n" +
                "  NULL AS C_FROM_PLY_MRK,\n" +
                "  NULL AS C_PLAN_NO,\n" +
                "  NULL AS C_CLAIM_TYPE,\n" +
                "  NULL AS C_IS_HOSPITAL,\n" +
                "  a.C_EDR_NO,\n" +
                "  NULL AS C_SUB_GRP_NO,\n" +
                "  NULL AS C_IS_THERE_ASOCIAL_SECURITY");
        table.put("filed_n","C_PK_ID,C_CLM_NO,C_INSURED_CDE,C_INSURED_NME,C_SEX,N_AGE,C_CERT_TYP,C_CERT_NO,C_OCCUP_CDE,C_CRT_CDE,T_CRT_TM,C_UPD_CDE,T_UPD_TM,C_INJURED,C_HOSPITAL,C_ACCDNT_PK_ID,C_OCCUP_DTL,C_OCCUP_CNM,C_OCCUP_TYPE,C_ACCDNT_CDE,C_ACCDNT_NME,C_FROM_PLY_MRK,C_PLAN_NO,C_CLAIM_TYPE,C_IS_HOSPITAL,C_EDR_NO,C_SUB_GRP_NO,C_IS_THERE_ASOCIAL_SECURITY");
        table.put("where_sql","(\n" +
                "    SELECT\n" +
                "      b.C_CLM_NO AS C_CLM_NO,\n" +
                "      b.C_INSURED_CDE AS C_INSURED_CDE,\n" +
                "      b.C_INSURED_NME AS C_INSURED_NME,\n" +
                "      b.C_INSURED_CDE AS C_ACCDNT_CDE,\n" +
                "      b.C_INSURED_NME AS C_ACCDNT_NME,\n" +
                "      b.C_SEX AS C_SEX,\n" +
                "      b.N_AGE AS N_AGE,\n" +
                "      b.C_CERT_TYP AS C_CERT_TYP,\n" +
                "      b.C_CERT_NO AS C_CERT_NO,\n" +
                "      b.C_OCCUP_CDE AS C_OCCUP_CDE,\n" +
                "      b.C_CRT_CDE AS C_CRT_CDE,\n" +
                "      b.T_CRT_TM AS T_CRT_TM,\n" +
                "      b.C_UPD_CDE AS C_UPD_CDE,\n" +
                "      b.T_UPD_TM AS T_UPD_TM,\n" +
                "      b.C_HOSPITAL AS C_HOSPITAL,\n" +
                "      b.C_INS_ACC_PK_ID AS C_ACCDNT_PK_ID,\n" +
                "      t.C_EDR_NO AS C_EDR_NO \n" +
                "    FROM\n" +
                "      PCISV6.WEB_CLM_MAIN_END t,\n" +
                "      PCISV6.WEB_CLM_ACCDNT b \n" +
                "  WHERE\n" +
                "    t.C_CLM_NO = b.C_CLM_NO AND ${WHERE}) a");
        table.put("BTS","M");
        table.put("lowerCase","false");
        table.put("year_cs","false");
        OracleTableList.add(table);


        oracleServer.tableTONewTableYearsCG(OracleTableList);
    }


    public static void tableYear(ConfigurableApplicationContext run){
        OracleServer oracleServer = run.getBean(OracleServer.class);
        Map<String,String> table = new HashMap<>();

        table.put("table","WEB_PLY_CI");
        table.put("sql","CREATE TABLE \"PCISV6_2\".\"WEB_PLY_CI\" (\n" +
                "  \"c_pk_id\" NVARCHAR2(50) NOT NULL,\n" +
                "  \"c_app_no\" NVARCHAR2(50),\n" +
                "  \"c_row_id\" NVARCHAR2(50),\n" +
                "  \"c_ply_no\" NVARCHAR2(50),\n" +
                "  \"n_edr_prj_no\" NUMBER(11,0),\n" +
                "  \"c_edr_no\" NVARCHAR2(50),\n" +
                "  \"n_seq_no\" NUMBER(11,0),\n" +
                "  \"c_ci_agrmnt_no\" NVARCHAR2(50),\n" +
                "  \"c_major_agrmnt_mrk\" NCHAR(1),\n" +
                "  \"c_coinsurer_cde\" NVARCHAR2(30),\n" +
                "  \"c_chief_mrk\" NCHAR(1),\n" +
                "  \"c_issue_mrk\" NCHAR(1),\n" +
                "  \"n_ci_share\" NUMBER,\n" +
                "  \"n_ci_amt\" NUMBER,\n" +
                "  \"n_ci_rate\" NUMBER,\n" +
                "  \"n_ci_prm\" NUMBER,\n" +
                "  \"n_comm\" NUMBER,\n" +
                "  \"n_ply_fee\" NUMBER,\n" +
                "  \"n_ci_amt_var\" NUMBER,\n" +
                "  \"n_ci_prm_var\" NUMBER,\n" +
                "  \"n_comm_var\" NUMBER,\n" +
                "  \"n_ply_fee_var\" NUMBER,\n" +
                "  \"c_self_mrk\" NCHAR(1),\n" +
                "  \"c_latest_mrk\" NCHAR(1),\n" +
                "  \"t_crt_tm\" DATE,\n" +
                "  \"c_upd_cde\" NVARCHAR2(30),\n" +
                "  \"c_crt_cde\" NVARCHAR2(30),\n" +
                "  \"t_upd_tm\" DATE,\n" +
                "  \"c_trans_mrk\" NCHAR(1),\n" +
                "  \"t_trans_tm\" DATE,\n" +
                "  \"c_ci_sub_comp\" NVARCHAR2(200),\n" +
                "  \"c_dpt_mrk\" NVARCHAR2(10),\n" +
                "  \"c_acct_no\" NVARCHAR2(200),\n" +
                "  \"c_acct_nme\" NVARCHAR2(200),\n" +
                "  \"c_bank_rel_typ\" NVARCHAR2(300),\n" +
                "  \"c_bank_little\" NVARCHAR2(50),\n" +
                "  \"c_bank_pro\" NVARCHAR2(30),\n" +
                "  \"c_bank_area\" NVARCHAR2(30),\n" +
                "  \"c_bank_county\" NVARCHAR2(300),\n" +
                "  \"c_bank_cde\" NVARCHAR2(300),\n" +
                "  \"c_bank_cnaps\" NVARCHAR2(300),\n" +
                "  \"c_bank_addr\" NVARCHAR2(300),\n" +
                "  \"c_pub_pri\" NVARCHAR2(30),\n" +
                "  \"c_pay_type\" NVARCHAR2(50),\n" +
                "  \"c_sls_id\" NVARCHAR2(20),\n" +
                "  \"c_sls_nme\" NVARCHAR2(50),\n" +
                "  \"c_sls_cde\" NVARCHAR2(20),\n" +
                "  \"c_dptply_cde\" NVARCHAR2(500),\n" +
                "  \"n_notax_prm\" NUMBER,\n" +
                "  \"n_added_tax\" NUMBER,\n" +
                "  \"n_notax_prm_var\" NUMBER,\n" +
                "  \"n_added_tax_var\" NUMBER,\n" +
                "  \"n_notax_ply_fee\" NUMBER,\n" +
                "  \"n_notax_ply_fee_var\" NUMBER,\n" +
                "  \"n_added_tax_fee\" NUMBER,\n" +
                "  \"n_added_tax_fee_var\" NUMBER,\n" +
                "  \"n_ply_fee_rate\" NUMBER,\n" +
                "  \"c_ji_mrk\" NCHAR(1),\n" +
                "  \"c_dpt_cde\" NVARCHAR2(90),\n" +
                "  \"c_companyname_old\" NVARCHAR2(50),\n" +
                "  \"c_crt_cde_old\" NVARCHAR2(50),\n" +
                "  \"c_upd_cde_old\" NVARCHAR2(50),\n" +
                "  \"c_policy_no\" NVARCHAR2(50),\n" +
                "  \"c_sub_dpt_cde\" NVARCHAR2(30),\n" +
                "  \"c_brkr_cde\" NVARCHAR2(30),\n" +
                "  \"c_brk_sls_cde\" NVARCHAR2(200),\n" +
                "  \"c_agt_agr_no\" NVARCHAR2(30),\n" +
                "  \"n_ci_no\" NUMBER,\n" +
                "  \"c_link_man\" NVARCHAR2(50),\n" +
                "  \"c_contact_typ\" NVARCHAR2(50),\n" +
                "  \"c_ci_dpt\" NVARCHAR2(50),\n" +
                "  \"c_yu_liu_1\" NVARCHAR2(200),\n" +
                "  \"c_yu_liu_2\" NVARCHAR2(200),\n" +
                "  \"c_yu_liu_3\" NVARCHAR2(200),\n" +
                "  \"c_yu_liu_4\" NVARCHAR2(50),\n" +
                "  \"c_yu_liu_5\" NVARCHAR2(50),\n" +
                "  \"c_yu_liu_6\" NVARCHAR2(50),\n" +
                "  \"c_yu_liu_7\" NVARCHAR2(50),\n" +
                "  \"c_yu_liu_8\" NVARCHAR2(50),\n" +
                "  \"n_yu_liu_1\" NUMBER,\n" +
                "  \"n_yu_liu_2\" NUMBER,\n" +
                "  \"n_yu_liu_3\" NUMBER,\n" +
                "  \"n_yu_liu_4\" NUMBER,\n" +
                "  \"n_yu_liu_5\" NUMBER,\n" +
                "  \"n_yu_liu_6\" NUMBER(11,0),\n" +
                "  \"n_yu_liu_7\" NUMBER(11,0),\n" +
                "  \"n_yu_liu_8\" NUMBER(11,0),\n" +
                "  \"n_yu_liu_9\" NUMBER(11,0),\n" +
                "  \"n_yu_liu_10\" NUMBER(11,0),\n" +
                "  \"t_yu_liu_1\" DATE,\n" +
                "  \"t_yu_liu_2\" DATE,\n" +
                "  \"t_yu_liu_3\" DATE,\n" +
                "  \"n_ci_net_prm\" NUMBER,\n" +
                "  \"n_ci_net_prm_var\" NUMBER\n" +
                ")\n" +
                "LOGGING\n" +
                "NOCOMPRESS\n" +
                "PCTFREE 10\n" +
                "INITRANS 1\n" +
                "STORAGE (\n" +
                "  INITIAL 65536 \n" +
                "  NEXT 1048576 \n" +
                "  MINEXTENTS 1\n" +
                "  MAXEXTENTS 2147483645\n" +
                "  BUFFER_POOL DEFAULT\n" +
                ")\n" +
                "PARALLEL 1\n" +
                "NOCACHE\n" +
                "DISABLE ROW MOVEMENT\n" +
                ";\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_pk_id\" IS '主键id';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_app_no\" IS '申请单号,批改申请单号';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_row_id\" IS '记录唯一标识号,投保时为投保单的PKID，批改申请时如非新增记录则为原投保单的PKID，如为新增记录则为批改申请单的PKID';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_ply_no\" IS '保单号,保单号 Policy No';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_edr_prj_no\" IS '批改次数/批改序号';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_edr_no\" IS '批单号';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_seq_no\" IS '序号';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_ci_agrmnt_no\" IS '共保协议号';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_major_agrmnt_mrk\" IS '主从协议标志';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_coinsurer_cde\" IS '共保公司';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_chief_mrk\" IS '主共标志';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_issue_mrk\" IS '出单标志';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ci_share\" IS '联共保比例';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ci_amt\" IS '联共保保额';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ci_rate\" IS '共保费率';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ci_prm\" IS '联共保保费';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_comm\" IS '代理经纪费';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ply_fee\" IS '出单费用';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ci_amt_var\" IS '保额变化';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ci_prm_var\" IS '保费变化';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_comm_var\" IS '代理经纪费变化';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ply_fee_var\" IS '出单费变化';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_self_mrk\" IS '本公司标志';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_latest_mrk\" IS '最新保单标志,0否,1是';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"t_crt_tm\" IS '创建时间';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_upd_cde\" IS '修改人代码';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_crt_cde\" IS '创建人代码';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"t_upd_tm\" IS '修改时间';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_trans_mrk\" IS '迁移标志';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"t_trans_tm\" IS '迁移时间';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_ci_sub_comp\" IS '共保子公司';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_dpt_mrk\" IS '出单机构标志';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_acct_no\" IS '收款人账号';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_acct_nme\" IS '收款人户名';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_bank_rel_typ\" IS '收款银行大类';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_bank_little\" IS '银行小类';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_bank_pro\" IS '开户行省';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_bank_area\" IS '开户行市';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_bank_county\" IS '开户行县';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_bank_cde\" IS '开户行';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_bank_cnaps\" IS 'CNAPS号';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_bank_addr\" IS '开户行地址';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_pub_pri\" IS '对公对私';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_pay_type\" IS '支付类型';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_sls_id\" IS '业务员代码';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_sls_nme\" IS '业务员名称';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_sls_cde\" IS '业务员';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_dptply_cde\" IS '出单机构代码';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_notax_prm\" IS '不含税保费';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_added_tax\" IS '增值税额';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_notax_prm_var\" IS '不含税保费变化';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_added_tax_var\" IS '增值税额变化';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_notax_ply_fee\" IS '不含税出单费';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_notax_ply_fee_var\" IS '不含税出单费变化';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_added_tax_fee\" IS '出单费增值税额';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_added_tax_fee_var\" IS '出单费增值税额变化';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ply_fee_rate\" IS '出单费比例';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_ji_mrk\" IS '主从联标识';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_dpt_cde\" IS '出单机构';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_companyname_old\" IS '老系统公司名称';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_crt_cde_old\" IS '旧创建人';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_upd_cde_old\" IS '旧更新人';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_policy_no\" IS '保单编号';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_sub_dpt_cde\" IS '分公司';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_brkr_cde\" IS '代理经纪人';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_brk_sls_cde\" IS '代理业务员';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_agt_agr_no\" IS '代理协议或合作协议号';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ci_no\" IS '联共保单号';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_link_man\" IS '联系人';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_contact_typ\" IS '联系方式';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_ci_dpt\" IS '联保机构 (新增)';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_yu_liu_1\" IS '预留字符字段1,预留';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_yu_liu_2\" IS '预留字符字段2,预留';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_yu_liu_3\" IS '预留字符字段3,预留';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_yu_liu_4\" IS '预留文本字段4';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_yu_liu_5\" IS '预留文本字段5';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_yu_liu_6\" IS '预留文本字段6';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_yu_liu_7\" IS '预留文本字段7';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"c_yu_liu_8\" IS '预留文本字段8';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_yu_liu_1\" IS '预留数值字段1';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_yu_liu_2\" IS '预留数值字段2';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_yu_liu_3\" IS '预留数值字段3';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_yu_liu_4\" IS '预留数值字段4';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_yu_liu_5\" IS '预留数值字段5';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_yu_liu_6\" IS '预留数值字段6';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_yu_liu_7\" IS '预留数值字段7';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_yu_liu_8\" IS '预留数值字段8';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_yu_liu_9\" IS '预留数值字段9';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_yu_liu_10\" IS '预留数值字段10';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"t_yu_liu_1\" IS '预留时间字段1';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"t_yu_liu_2\" IS '预留时间字段2';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"t_yu_liu_3\" IS '预留时间字段3';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ci_net_prm\" IS '共保净保费';\n" +
                "COMMENT ON COLUMN \"PCISV6_2\".\"WEB_PLY_CI\".\"n_ci_net_prm_var\" IS '共保净保费变化量';\n" +
                "COMMENT ON TABLE \"PCISV6_2\".\"WEB_PLY_CI\" IS '联共保信息表';");

        oracleServer.tableYearCreat(table);
    }















    // 备份--》uat [单证全量]
    public static void B_M(ConfigurableApplicationContext run) throws Exception {
        OracleServer oracleServer = run.getBean(OracleServer.class);

        List<Map<String,String>> OracleTableList = new ArrayList<>();
        Map<String,String> table = new HashMap<>();

        // 0
//        table = new HashMap<>();
//        table.put("table","WEB_VCH_APP");
//        table.put("id","C_APP_ID");
//        table.put("way","increment");
//        table.put("inc_field","T_UPD_TM");
//        OracleTableList.add(table);

        // 0
//        table = new HashMap<>();
//        table.put("table","WEB_VCH_APP_OPIN");
//        table.put("id","C_PK_ID");
//        table.put("way","increment");
//        table.put("inc_field","T_UPD_TM");
//        OracleTableList.add(table);

        // 0
//        table = new HashMap<>();
//        table.put("table","WEB_VCH_OPERLOG");
//        table.put("id","C_PK_ID");
//        table.put("way","increment");
//        table.put("inc_field","T_UPD_TM");
//        OracleTableList.add(table);

        // 0
//        table = new HashMap<>();
//        table.put("table","WEB_VCH_PRNBATCH");
//        table.put("id","C_PK_ID");
//        table.put("way","increment");
//        table.put("inc_field","T_UPD_TM");
//        OracleTableList.add(table);

        // 0
//        table = new HashMap<>();
//        table.put("table","WEB_VCH_TYPEINFO");
//        table.put("id","C_PK_ID");
//        table.put("way","increment");
//        table.put("inc_field","T_UPD_TM");
//        OracleTableList.add(table);

        // 2011-06-25
        table = new HashMap<>();
        table.put("table","WEB_VCH_PRNEXPEND");
        table.put("id","C_PK_ID");
        table.put("way","increment");
        table.put("inc_field","T_UPD_TM");
        OracleTableList.add(table);

        oracleServer.OracleToMysqlToDate(OracleTableList);
    }



}
